﻿CREATE PROCEDURE dbo.uspPayAndReceiveItemDeleteByField
	@fieldName nvarchar(100),
	@value nvarchar(1000)
AS
BEGIN
	DECLARE @query nvarchar(2000)
	SET @query = 'DELETE FROM [PayAndReceiveItem] WHERE [' + @FieldName + '] = ''' + @value + ''''
	EXEC(@query)
END